{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Folha1","Folha2","Folha3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Folha1","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Exemplo. Venda de seguros da Cosmic"]
[null,"Lanç. Moeda","NPA","Result. Moeda","Int. Seguro","Lanç.","NPA","Resultado","Valor Seguro (Mil €)","Valor","Auxiliar1","Auxiliar2","Auxiliar3"]
[null,"N",null,"F=0-0,5; C=0,5-1","S=1;N=0","Dado?","Dado","Dado","\"0\"; \"10\"; \"20\"","€","Venda","Venda=10","Venda=20"]
[null,1,{"$f":"RAND()","v":0.95450791378079303},{"$f":"IF(C5<0.5, \"F\", \"C\")","v":"C"},{"$f":"IF(D5=\"F\", \"Sim\", \"Não\")","v":"Não"},{"$f":"IF(E5=\"Não\", \"Não\", \"Sim\")","v":"Não"},{"$f":"IF(F5=\"Não\", \"Não\", RAND())","v":"Não"},{"$f":"IF(G5=\"Não\",0,IF(G5<1/6,1,IF(G5<2/6,2,IF(G5<3/6,3,IF(G5<4/6,4,IF(G5<5/6,5,6))))))","v":0},{"$f":"IF(H5<4,0, IF(H5<6, 10,20))","v":0},{"$f":"+I5*1000","v":0},{"$f":"IF(I5=0,0, 1)","v":0},{"$f":"IF(I5=10,1, 0)","v":0},{"$f":"IF(I5=20,1, 0)","v":0}]
[null,{"$f":"+B5+1","v":2},{"$f":"RAND()","v":0.66241560285644752},{"$f":"IF(C6<0.5, \"F\", \"C\")","v":"C"},{"$f":"IF(D6=\"F\", \"Sim\", \"Não\")","v":"Não"},{"$f":"IF(E6=\"Não\", \"Não\", \"Sim\")","v":"Não"},{"$f":"IF(F6=\"Não\", \"Não\", RAND())","v":"Não"},{"$f":"IF(G6=\"Não\",0,IF(G6<1/6,1,IF(G6<2/6,2,IF(G6<3/6,3,IF(G6<4/6,4,IF(G6<5/6,5,6))))))","v":0},{"$f":"IF(H6<4,0, IF(H6<6, 10,20))","v":0},{"$f":"+I6*1000","v":0},{"$f":"IF(I6=0,0, 1)","v":0},{"$f":"IF(I6=10,1, 0)","v":0},{"$f":"IF(I6=20,1, 0)","v":0}]
[null,{"$f":"+B6+1","v":3},{"$f":"RAND()","v":0.42234168523381899},{"$f":"IF(C7<0.5, \"F\", \"C\")","v":"F"},{"$f":"IF(D7=\"F\", \"Sim\", \"Não\")","v":"Sim"},{"$f":"IF(E7=\"Não\", \"Não\", \"Sim\")","v":"Sim"},{"$f":"IF(F7=\"Não\", \"Não\", RAND())","v":0.55064158533908503},{"$f":"IF(G7=\"Não\",0,IF(G7<1/6,1,IF(G7<2/6,2,IF(G7<3/6,3,IF(G7<4/6,4,IF(G7<5/6,5,6))))))","v":4},{"$f":"IF(H7<4,0, IF(H7<6, 10,20))","v":10},{"$f":"+I7*1000","v":10000},1,1,0]
[null,4,0.43948246824553983,"F","Sim","Sim",1.6188332342705558E-2,1,0,0,0,0,0]
[null,5,0.85881595061093974,"C","Não","Não","Não",0,0,0,0,0,0]
[null,6,0.42104880024288571,"F","Sim","Sim",0.57389523007910304,4,10,10000,1,1,0]
[null,7,0.33807033180839841,"F","Sim","Sim",0.89331084166432284,6,20,20000,1,0,1]
[null,8,0.79173476623316763,"C","Não","Não","Não",0,0,0,0,0,0]
[null,9,0.82393630712275545,"C","Não","Não","Não",0,0,0,0,0,0]
[null,10,0.185710139288776,"F","Sim","Sim",7.2043343665952109E-2,1,0,0,0,0,0]
[null,11,8.1277069983579531E-2,"F","Sim","Sim",4.5192295127032267E-2,1,0,0,0,0,0]
[null,12,0.2075296116434362,"F","Sim","Sim",0.32769786515406285,2,0,0,0,0,0]
[null,13,0.53330817655101803,"C","Não","Não","Não",0,0,0,0,0,0]
[null,14,0.6642374355393118,"C","Não","Não","Não",0,0,0,0,0,0]
[null,15,0.8294144657934801,"C","Não","Não","Não",0,0,0,0,0,0]
[null,16,0.38383579522598488,"F","Sim","Sim",0.22530426987520957,2,0,0,0,0,0]
[null,17,0.83785038680308088,"C","Não","Não","Não",0,0,0,0,0,0]
[null,18,0.80760626580029882,"C","Não","Não","Não",0,0,0,0,0,0]
[null,19,0.17045536839857356,"F","Sim","Sim",0.98734805353507338,6,20,20000,1,0,1]
[null,20,0.30190422347224677,"F","Sim","Sim",0.67092783331550743,5,10,10000,1,1,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K24)","v":5},{"$f":"SUM(L5:L24)","v":3},{"$f":"SUM(M5:M24)","v":2}]
[null,null,null,"Comparação de resultados teóricos e resultados simulados"]
[null,null,null,"Probab.","Probab.","Dada uma","Venda "]
[null,null,null,"Venda","Não  Venda","P(venda=10)","P(venda=20)",null,"Valor Esperado",null,"Amostra","P(Venda)","P(V=10/V)","P(V=20/V)","V. Esp"]
[null,"Simulados",null,{"$f":"+K25/B24","v":0.25},{"$f":"1-D29","v":0.75},{"$f":"+L25/K25","v":0.6},{"$f":"+M25/K25","v":0.4},null,{"$f":"F29*10000+G29*20000","v":14000},null,null,{"$f":"AVERAGE(L31:L41)","v":0.23636363636363636},{"$f":"AVERAGE(M31:M41)","v":0.76363636363636367},{"$f":"AVERAGE(N31:N41)","v":0.69264069264069261},{"$f":"AVERAGE(O31:O41)","v":13073.593073593074}]
[null,"teóricos",null,{"$f":"0.5*0.5","v":0.25},{"$f":"0.5+0.5*0.5","v":0.75},{"$f":"+(1/3*1/2)/(1/3*1/2+1/6*1/2)","v":0.66666666666666663},{"$f":"+(1/6*1/2)/(1/3*1/2+1/6*1/2)","v":0.33333333333333331},null,{"$f":"F30*10000+G30*20000","v":13333.333333333332}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D29","v":0.25},{"$f":"E29","v":0.75},{"$f":"F29","v":0.6},{"$f":"I29","v":14000}]
[null,null,null,null,null,null,null,null,null,null,1,0.25,0.75,1,10000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K32+1","v":2},0.4,0.6,0.75,12500]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K33+1","v":3},0.3,0.7,0.83333333333333337,11666.666666666668]
[null,null,null,null,null,null,null,null,null,null,4,0.25,0.75,0.6,14000]
[null,null,null,null,null,null,null,null,null,null,5,0.2,0.8,0.75,12500]
[null,null,null,null,null,null,null,null,null,null,6,0.35,0.65,0.2857142857142857,17142.857142857145]
[null,null,null,null,null,null,null,null,null,null,7,0.05,0.95,0,20000]
[null,null,null,null,null,null,null,null,null,null,8,0.2,0.8,1,10000]
[null,null,null,null,null,null,null,null,null,null,9,0.25,0.75,0.8,12000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K40+1","v":10},0.1,0.9,1,10000]

{"sheet":"Folha2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Folha3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}